SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029583 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029583 [ RunTime:0.005148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598508,1009440,680546,186283,951036,338845,68677,215998,17092,847205,757113,636491,275447,711537,266136,864178,660791,219024,471893,324063,369815,306400,237601,804164,347537,244982,414000,196701,434136,96203,156691,632593,955707,921458,354188,865901,93768,837389,561507,719855,266823,598554,845785,683792,447512,388442,499784,991440,943885,574865,505625,538077,890226,296622,220839,777650,1035088,56836,853719,372704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]