SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409122 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409122 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914539,448740,731224,190436,480213,1007018,556386,664121,262601,935660,1044111,466742,77301,35054,585353,376470,495708,824866,248003,849588,522519,26279,818756,361344,560895,223797,721486,194531,787958,870752,698843,427520,105340,681581,966760,665170,340239,114022,275587,826236,772632,838916,666201,530014,490330,579061,963067,460518,557652,989337,185812,946997,742107,835892,449499,993640,114068,315928,1026558,783326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]