SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319294 LIMIT 1 [ RunTime:0.004464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319294 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606945,151379,12025,347701,475558,460131,1038291,494679,446354,321959,596281,628605,763012,509559,1003756,464242,483097,408875,213789,11121,853124,458261,278015,581418,865454,623783,971523,439355,120408,269001,606837,890931,181978,695582,867082,70440,786842,731072,85654,455760,287923,554371,1036819,923567,784973,210924,150954,188399,320750,450276,822985,200222,489545,627141,418861,120383,140388,38171,768180,494343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]