SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802004 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802004 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475315,101757,992370,148268,666984,985062,343773,739304,580467,562877,1030635,10032,711004,823039,1026831,1042926,404376,119317,782536,738193,345144,497492,668599,358607,896255,442568,214097,856476,993522,965251,739987,127448,965054,881139,436331,669291,11449,776385,421506,738918,636052,764636,596413,59418,953876,684481,995159,342474,31749,957217,260037,893388,168272,805084,759707,849441,580007,290873,810343,281694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]