SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036106 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036106 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227535,313637,492138,448326,465577,455312,241609,368184,858059,89744,751658,12944,761762,982631,527745,692920,801300,800777,996325,922395,159116,432249,760901,171662,227033,1029289,96553,905909,108087,57133,821760,991103,883823,72963,290864,731739,289800,43505,415835,505259,35226,1000489,1012469,311316,675097,826736,215882,1039755,387608,686485,90370,858924,748683,1047198,1034891,343591,106970,717716,191095,284048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]