SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030686 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030686 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309098,361613,247783,93666,210453,954055,673573,1018152,94178,746296,554079,638789,771689,902806,934146,377892,831815,511647,78720,562843,910645,270271,282927,887489,488786,557538,1006952,214196,743375,799250,547023,96559,875449,295740,523426,702845,924322,668413,923080,63357,685339,561173,416391,34649,723543,79836,282500,736534,657176,495057,452438,867949,616239,813757,1022601,740942,5565,13749,827075,244779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]