SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4581 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4581 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505001,893216,246166,283637,1002689,617734,92901,982465,396927,593388,17537,217190,158277,465883,742886,920011,4421,61749,211518,478445,2181,555604,548072,726126,698950,707289,235845,471833,417131,780055,529456,782975,209025,846172,423222,581923,901373,965610,158856,369395,468739,529446,322348,368042,493344,463541,285199,444356,306019,80416,73849,886976,177258,964304,664953,738702,65504,920229,991287,779229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]