SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401067 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401067 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177579,730804,576413,443003,751037,119512,696377,931806,968627,86409,735602,998329,168115,760417,719717,480299,540372,675894,7881,506013,1010026,1019289,408362,766236,345343,196275,815401,907558,210458,526976,1027973,465695,642856,396252,423784,757353,746040,595518,228065,842394,571718,48471,499194,1016504,142810,860101,161571,922439,700809,52817,1024675,821212,288981,446072,831267,101380,62337,17538,620740,148913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]