SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974006 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974006 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434058,574119,494580,846631,148139,537573,737160,895862,159800,1010486,378938,151246,706285,48414,947009,731345,693500,821144,1044897,626040,109055,981344,724191,393122,97232,318703,822493,122202,1024917,581165,288224,82186,566163,494118,752292,793134,907096,501940,262381,640574,930051,24053,265157,505343,23101,648880,753285,352778,464994,238255,20392,682860,870260,396563,609026,246428,424200,172125,598492,717899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]