SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407454 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407454 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41932,284468,674900,637021,767442,555257,229830,419248,982711,92958,1002264,592072,649904,239964,560448,212494,515112,642879,514725,763764,3100,619082,310269,533474,395371,414816,1030166,103068,49006,560706,881660,1002657,529783,158771,385480,800474,161552,605485,997182,13659,128711,232571,255639,482589,790177,557381,688820,325646,967409,691153,24945,165812,859790,1013880,624049,327873,281328,819185,883449,473588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]