SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399838 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399838 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616108,548310,450519,705946,687296,260638,1025811,456848,413730,395696,166991,380190,409827,655983,843381,629527,1048626,447156,844700,657297,768728,591546,210061,51466,967991,212047,929136,519701,355849,26325,77276,707199,909292,666875,219990,293972,595870,655,370390,515761,118287,964184,101519,584864,858750,635884,589687,648153,187896,644666,133913,401568,61890,169640,858408,432345,325036,128,1013577,605481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]