SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403409 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403409 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175215,968047,721876,817690,974809,472998,375866,682567,515115,924085,60634,531883,168614,510175,111281,627533,472195,548220,448601,112217,401590,629796,25341,631481,611487,354909,635545,728037,696407,1030185,139812,805591,1016389,482061,224515,756405,236347,397921,84506,1016130,224452,736111,281673,86722,365771,546003,652024,251436,581555,690145,199106,855369,437125,848609,530546,725024,320089,477726,565850,393349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001360s ]