SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492411 LIMIT 1 [ RunTime:0.001594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492411 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38432,394827,657182,357066,936572,135569,434818,871484,412448,164853,306996,697441,757795,518947,906098,965397,953458,930679,785771,320610,521325,1016284,1046157,492705,91291,691789,605994,740689,339124,650317,173712,67651,755713,499361,299832,797858,274905,278271,462263,200965,21002,78196,1017140,895992,501777,897994,926072,459107,137436,956874,463736,1011582,900774,884595,770334,196119,69037,543159,538,383748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]