SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468293 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468293 [ RunTime:0.003098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143148,802202,292276,778502,602032,843121,926694,156262,81351,779775,620975,336239,536458,624821,270828,821433,617337,1007429,522461,18964,236623,612225,926145,811511,1009079,654414,1014482,1005300,73552,730163,617384,383377,234970,164139,517509,914001,70004,852917,567221,1037325,267993,99052,269060,349469,769581,881376,460023,341315,682910,609200,353191,1013414,38681,351727,767632,643824,8636,762245,574171,399801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]