SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047673 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047673 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89280,23165,273540,142404,960889,582292,68055,131348,706116,254626,710838,13994,937656,992659,817896,865468,734288,833307,130067,115309,698177,884063,811377,617498,825235,705784,111954,231032,422311,329252,263834,38915,891763,1002345,399560,595038,114601,991329,614749,800054,1026182,392090,227423,793678,409854,995251,243897,969800,299500,199387,898859,923063,150340,469001,129807,89971,495879,1000276,821078,570563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004194s ]