SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554910 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554910 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566659,969606,966428,476709,926219,619999,457005,587545,616920,716571,455364,909643,608234,898422,231544,222759,559468,71783,805226,31193,331110,526991,196581,385062,105106,661733,71002,232337,859011,191983,690070,277740,848610,457147,73969,242195,468568,580779,699222,202301,386040,349242,887895,160012,494037,470526,381555,979353,823819,638414,698533,986086,49647,841428,462963,158090,106938,84886,60262,797466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]