SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505623 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505623 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210368,850407,585577,396713,480463,321291,971001,495826,118421,411213,838686,65852,510568,969792,993362,735602,279128,323504,990313,762318,811119,509460,352781,734023,480160,958996,817321,247011,502829,284696,15634,276701,890997,232895,555316,521926,888961,772454,780963,429556,880778,30682,408762,218535,629891,293530,991974,398078,667858,575184,370144,19647,51135,376327,223515,323341,251264,885055,507699,626297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]