SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200570 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200570 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829578,309465,167917,188348,390014,195450,994410,508362,693176,425065,258,389931,1031135,1004592,511714,332633,625422,740556,447194,285137,873105,790374,420910,161481,114594,865301,874312,213157,382785,106306,712088,42924,607814,732652,337089,249968,1006104,6533,970300,577323,780331,222134,103108,954286,557046,823968,632977,189651,977749,888477,440699,301199,481135,626366,306869,109154,651138,570249,574487,891369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]