SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409145 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409145 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99743,826047,517962,620482,832307,19913,776839,366448,263020,1041122,476158,352066,321417,147266,922385,984192,481020,906352,108277,526979,111864,974930,82074,919791,350481,1326,408362,557522,823614,202709,377262,892801,339953,608155,514214,567345,801543,989786,452726,870842,310424,640709,501492,888375,235508,909639,675924,1048354,247175,728548,867633,749637,112497,256858,818032,232841,325201,172632,228394,357315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]