SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281518 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281518 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903053,1011855,467616,424937,921110,272467,596392,824782,264661,54259,100816,304831,892454,754488,162160,325701,817843,414649,586093,606292,80250,504057,485426,322247,604294,658744,702583,189729,385978,827599,866021,461758,641639,869847,618266,866901,166704,672912,88974,768550,425823,938620,950042,521330,975643,58520,579896,1016530,902977,214153,957244,856552,507747,965800,586690,450720,636652,513175,58679,885445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]