SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428814 LIMIT 1 [ RunTime:0.001643s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428814 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776258,47356,613467,923838,267376,715014,314404,130601,156583,48108,641143,317476,1035409,577501,98737,5762,971107,848298,899297,873352,208772,402312,546280,814505,419906,372745,454928,154367,9823,1027331,976870,70564,663608,315254,608191,616405,1002273,599730,884853,1014908,465127,1025598,788783,879774,34105,844847,500632,1045696,165391,152177,177566,664196,284122,107740,601943,889546,771910,807712,156921,42589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]