SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405011 LIMIT 1 [ RunTime:0.003111s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405011 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523603,692564,623604,452816,110423,613846,716978,36983,946189,99112,686137,673489,875740,678548,412964,672147,848075,696937,959594,601271,566976,431021,72243,256400,962099,15758,435042,775045,950364,780394,689390,577369,248519,5208,519692,780149,994973,953860,1015573,386230,485623,18107,593835,579581,641938,203344,310389,591351,708162,1023757,1048866,1048103,627132,869901,346510,398009,196495,683409,816703,326751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]