SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501347 LIMIT 1 [ RunTime:0.001400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501347 [ RunTime:0.004899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454079,285074,555518,760629,570130,15370,145442,132739,585366,953658,946975,889253,262717,206951,438587,391675,88786,1045474,521812,641231,216783,977068,441405,954534,333082,194348,102699,259582,401586,245206,70028,345558,358739,1023094,680354,330240,773022,590750,940993,794967,148992,409311,325135,639069,684601,1011347,691375,806116,859341,587316,711576,612502,961564,328077,889562,332500,410906,384541,442373,193782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]