SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537231 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537231 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435097,1039206,378853,978406,676284,218800,517885,621325,154403,454320,935483,331920,65566,53454,729749,956193,675957,128741,1028271,810990,277920,189147,206222,388803,958733,969656,612301,321191,653520,502327,844774,52328,32271,125061,1030587,983590,140449,763198,308875,804848,642174,641685,223624,1026665,602875,384637,765636,339074,367017,109421,103141,97370,145957,156891,423417,694122,295267,70495,77926,370902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]