SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452005 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452005 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229976,549873,780802,292493,442147,666589,372035,394449,139891,701535,623480,210202,276310,492731,620656,203681,758337,221779,953804,16036,403827,116815,473273,840477,283829,582158,686163,813455,666020,926922,41103,793797,520161,269717,26728,45446,784471,274516,276095,902450,430639,253247,944224,560015,127380,207764,346035,799531,807760,138054,60208,494202,46058,361301,617136,219738,456809,303607,1019332,777724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]