SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 71281 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 71281 [ RunTime:0.003950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356613,357412,401830,1003058,257628,972969,1044544,513429,215905,240680,245419,732167,648356,525061,733442,975317,910056,775737,330909,269011,131770,650432,873717,482943,542583,1004801,305661,865257,453837,893868,93035,598550,106338,796009,631743,560449,33784,662230,480605,424550,973378,142907,921327,690704,246069,570977,121516,959404,119975,84614,49869,408641,436247,237495,171531,486782,981214,373706,134332,859523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 71281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 71281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]