SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421063 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421063 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170874,339084,826265,352851,39726,818963,384030,798065,580571,458859,472270,434017,1021719,499132,7400,667016,239161,391140,1028691,22675,537688,557726,337250,667636,611777,941073,534405,468066,452450,943122,540275,302359,985541,239076,1003850,293850,206487,632635,435091,434565,455950,465632,1032902,181538,340876,294668,698457,416378,93496,685000,74314,193449,151489,256526,784114,756114,442051,220285,960559,583004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]