SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412258 LIMIT 1 [ RunTime:0.004362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412258 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2922,776552,163118,651265,548788,955401,998120,736614,281640,803430,263603,629158,567705,168069,310168,38890,162440,286368,514714,585463,727802,406861,956430,592733,372555,335239,731358,486762,667881,296405,983532,374943,417131,116525,96721,617302,60618,238875,448559,826974,214453,114450,866631,701037,703402,105977,64047,473100,1027257,928363,431440,181993,880639,989102,462549,835642,541683,48817,264162,670231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]