SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040848 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040848 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219682,934954,968540,855052,156952,1012106,470280,159206,46037,843417,837700,1038726,625548,420568,621649,261157,274697,814888,954760,922813,25922,95711,943506,645816,700116,792749,109324,802910,943716,535318,298639,21165,809917,452595,57493,1005620,417751,26016,262955,991954,898170,948464,124402,355166,22077,610419,333534,548127,797582,331369,519571,46197,25589,33465,297391,175788,465121,496343,31869,826373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]