SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415686 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415686 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895739,1043121,510114,519234,1019933,218302,37132,183342,595552,352408,131954,116784,1013816,891736,178528,74101,1037537,429981,911999,115887,132842,599557,889734,326039,559636,446226,244805,441897,554379,496636,289290,319032,567858,81804,580877,471848,184050,1037186,401369,409768,92186,965237,546338,758643,468264,193704,577529,87133,1040583,46955,35170,969768,508847,33229,174116,332216,727426,560005,828781,715526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]