SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193118 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193118 [ RunTime:0.003939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247524,502502,1015582,198628,845266,478753,480007,672933,553341,761477,908783,931949,490124,206743,1035685,921346,356268,367280,997635,316697,872262,824892,82056,725040,888644,450230,715835,480952,144530,1022583,893428,646719,651057,247345,955254,564008,761234,554954,897947,251449,461786,342695,300331,390813,892490,1042531,813814,153363,594718,381704,14855,240234,898271,379541,485211,447183,745943,374131,543654,217535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]