SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 288403 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 288403 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202215,370904,671264,325448,3951,81366,352257,984879,381090,810574,461366,55989,212456,970965,106647,910939,352213,398827,408566,355385,762265,864585,779043,61464,428698,29075,242930,463301,749091,722350,991437,443326,964576,1035342,302875,224724,756534,92216,378962,291044,565756,14266,966489,509198,629852,842822,972642,418916,214124,527734,812948,719596,274813,145075,449887,861379,292566,261358,100366,740918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 288403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 288403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]