SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531470 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531470 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515931,61669,184816,120398,130327,564932,998130,619242,395428,901525,887348,663569,347356,322042,1028411,690157,26342,851545,729244,996440,69354,262583,36569,92901,111531,743364,351054,727738,797923,863621,859835,976187,994530,771197,459723,63863,236856,886992,493549,307032,417182,520347,366816,376963,505269,225711,776319,693750,398295,954201,471457,383685,56857,225369,7735,805925,681916,523290,145792,444527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]