SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412521 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412521 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377509,351120,936247,201444,420187,377052,765184,610828,819646,399566,959926,223756,547937,205427,182479,389351,643961,196650,374649,352715,536051,308077,636693,719290,83882,886100,361100,336660,654440,859837,822204,849373,976131,849994,412757,438202,384711,542670,472740,364928,724562,505503,387138,1015732,602706,594220,274198,160314,83506,528177,55894,1009192,250240,528293,852451,877563,205917,491580,1047245,84752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]