SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398050 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398050 [ RunTime:0.005795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036997,767106,74867,454110,150295,513116,82458,793359,265680,701878,601164,727176,122548,436694,748795,820180,678687,811055,902581,1017679,352425,971577,766418,358463,102539,171990,494286,916443,1010192,901654,972519,595554,1018293,55233,960454,213528,159955,152473,689948,136099,901410,1041393,900397,281224,721937,513708,444083,496884,1042431,679172,11808,76635,26619,941754,207213,204988,903795,260104,767069,512044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]