SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426851 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426851 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039884,609313,643813,888490,1019861,772872,493113,347031,988002,908282,498776,714845,593391,745564,355862,981902,798907,329963,519909,345493,240074,317950,725421,925695,662745,711313,444233,971757,1014886,644162,532499,49632,31549,379907,992617,38801,467627,650380,150297,125703,284746,199691,213745,508245,87389,220891,731513,660096,503167,668494,307959,178344,876904,229977,514133,917718,484540,1045348,857688,838779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]