SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005023 LIMIT 1 [ RunTime:0.003929s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005023 [ RunTime:0.002175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5050,855395,144681,37972,886544,479120,762577,483322,549832,445298,913109,658345,352465,297650,606686,597028,791298,1020512,725916,696825,815983,151172,1038809,726468,314803,677158,26793,967514,594726,583112,378872,1048774,751491,138484,284070,131541,465345,192148,269741,909149,286650,33494,923415,673182,635719,929460,368574,1031216,454520,27754,528847,672685,830439,573516,36685,951231,81344,754154,913311,536627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]