SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429333 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429333 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803025,696322,95320,686715,408448,135130,254669,132572,181700,889512,533335,248194,143990,1038169,321428,552797,369946,651205,1007169,621570,837639,334021,166925,744525,464002,807510,608299,145787,751218,80382,1039896,738349,750730,478361,68372,281839,585291,341028,874912,512943,37998,936982,878779,389526,748905,827201,1048328,152470,116531,377750,1005559,562414,36542,348762,851998,438556,577406,802798,602410,904382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429333 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429333 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]