SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452947 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452947 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401774,577297,572189,875276,104844,446800,27530,110970,1940,501742,232695,98634,584739,442958,899516,421495,422829,146358,816685,566187,162241,269083,908916,60230,861167,282137,1010813,148917,812393,622587,525459,207090,302085,850118,146395,284695,887826,639595,856900,720100,985510,1023460,910317,120413,995382,293064,147164,924085,692113,168892,578904,646472,910563,402924,31036,858452,621742,992705,180935,272231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]