SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406679 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406679 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018708,189939,381602,244409,311439,669953,349353,752658,877678,286496,450019,612232,690878,368406,744152,630816,48096,590892,671691,769414,611686,622824,70014,508397,1011881,680833,614875,974443,822660,347255,783604,517121,737273,67875,690943,334534,36246,793350,479277,734623,955730,530788,1033086,692255,241387,927626,1032870,981081,818847,123197,365774,793463,691251,223034,273212,731665,983210,980391,436299,1002845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]