SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 371994 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 371994 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71407,560542,90060,937354,616678,187911,678797,72144,549633,485441,350264,459663,57828,173695,398048,983887,559076,153976,577946,202470,516894,237096,43919,644870,836043,521858,700079,572106,9883,671619,275368,903248,242888,752946,677932,744326,24313,790837,54049,825722,412612,108158,821696,981431,1040137,146095,463171,364506,191119,76504,463499,836755,170647,315218,353578,184714,704270,49308,714661,538156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 371994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 371994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]