SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416160 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416160 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239644,46646,90951,863157,706794,873698,723176,759914,16919,326824,810267,941626,910205,21483,370587,916180,890491,790825,25879,990311,204244,233119,821935,801937,157290,133296,700673,1007474,202696,638780,884876,267473,538598,82515,109520,673816,281158,728758,901124,795400,799395,912573,943646,209832,1017448,35478,942028,739112,167993,407577,180606,484917,896154,504225,19691,223640,482635,708317,564174,962622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]