SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504486 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504486 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377589,183688,640323,150624,906045,1025362,723093,429206,811693,983383,538265,541572,93774,188280,504462,656990,663520,179564,870207,816493,225995,810167,878802,133543,203111,1024112,947935,1001323,125007,820202,838968,853261,159132,797371,843157,125419,563115,489118,206998,333345,374836,983629,713725,826912,338154,139359,200458,565680,654892,880951,698341,269254,94655,32781,1041743,865204,912121,898580,544943,701096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]