SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231280 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231280 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027709,1040390,485957,366240,128298,384530,247488,634243,508674,35569,370632,47433,847332,802001,411600,211806,459867,173573,414505,641079,144970,338867,680990,39554,764286,688924,858203,609440,653315,585116,650842,850910,256245,728233,686189,994649,1033525,421134,59692,285764,191793,173734,151270,168011,816655,17993,655728,322191,375377,819206,228718,1032319,338136,300042,247313,478086,559290,668720,279818,798711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]