SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581205 LIMIT 1 [ RunTime:0.000746s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581205 [ RunTime:0.003246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300541,310698,716936,376133,329588,818667,1044379,544297,509351,380022,202310,498319,564433,472968,1013516,1013303,90226,810757,943408,880816,440710,73815,199770,191019,636377,197844,784721,1023682,16537,313192,445772,475415,266359,292539,1041781,846937,743919,893488,75715,1041131,199085,908072,606368,642591,323648,296212,754254,559233,535755,216628,443954,761251,867343,590837,954620,528477,148269,32004,711893,694608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]