SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036146 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036146 [ RunTime:0.002737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877417,1046391,837564,724600,906653,777287,630780,1016724,108948,838116,820866,821741,81562,100827,257773,225112,684428,121129,662619,464428,562002,199236,492639,314976,207227,531654,169620,599349,43504,531232,391317,895740,262820,409055,574178,141576,104428,78204,643226,30827,44820,241422,138141,963545,988113,771298,694009,263440,608461,448169,911928,696392,822193,12556,703549,25521,972468,510286,283220,93824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001551s ]