SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017424 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017424 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705310,682051,638948,884132,424686,484753,84099,587121,811890,568567,141299,17120,288193,240277,952122,502391,788794,852992,365441,995408,407973,387474,1030447,571841,245960,429796,316931,548616,946542,1045793,40167,829443,14188,352128,866799,1003647,270330,578990,990807,601455,592078,241644,588779,687887,1026209,514390,79578,871872,987668,838921,297192,456452,86680,481080,337083,985311,10524,826247,824499,784875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]