SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376723 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376723 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172990,903470,480021,423877,641352,116981,1005785,254410,545246,111134,624569,1013404,99831,557844,555647,668854,71548,748853,596492,912098,531707,451992,495862,281938,50550,885505,848205,981135,865315,1011759,244682,866440,782541,915145,736288,1038758,509345,909482,493120,429031,504533,512455,991057,829052,624394,69712,519037,345543,656141,648874,248508,193660,519177,350655,252877,1012630,93249,368885,998678,1036578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000358s ]