SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 931023 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 931023 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040874,519038,569895,406931,94414,7416,560152,826953,549278,556333,13832,220393,964058,317640,783230,501877,578309,868571,236217,974521,231038,777667,142651,319076,89260,953883,376730,396535,506094,376093,439128,370953,913458,906184,604935,381194,382617,860724,476388,949358,57258,602653,254331,144915,403329,699103,440406,947353,578649,270676,126047,95806,239142,976624,1048863,991951,422332,955551,492254,129082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 931023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 931023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]