SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047883 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047883 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334876,1012668,639276,796029,502845,518363,133559,1035566,72919,159100,488572,81213,659918,58725,678431,825491,546506,1016164,957349,931531,569438,960341,573287,614709,442980,883419,660876,817041,554182,692677,76253,319486,907625,814450,363152,581724,886262,914884,1048210,876848,526487,216441,174885,213102,508928,561710,372401,956774,788402,298759,447389,535324,381156,418453,1023296,758452,352717,318109,511771,830097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]