SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504887 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504887 [ RunTime:0.003818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650805,621651,990401,386815,631222,635584,1034626,376112,1003814,452528,1003249,1044171,762271,277853,384642,1036874,74477,975128,643414,172193,658605,216498,231742,150123,632015,294356,902702,245335,874081,135641,38338,934499,290322,316117,733120,882058,181746,1003010,515187,308701,322003,718293,1010568,140958,399829,406768,949510,1019978,689968,738980,199348,894324,577252,883343,368235,56482,891490,1025418,75767,390253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]