SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028805 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028805 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775547,441121,1029489,153245,450801,202788,94382,241301,1038808,264239,966597,999268,191424,537852,758967,530259,38982,288138,907766,529809,902640,42230,532085,831788,84067,226721,640909,142731,424999,777914,137495,386721,213989,335816,25514,182163,242925,516089,188090,922134,602710,846930,789133,161783,443954,405438,85262,806247,972798,396278,686775,596421,997810,770156,815778,897749,798617,1047556,868397,270259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]