SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102815 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102815 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514353,237123,849997,294736,234497,472351,944690,69241,616918,754314,412644,553764,295356,745191,223164,879733,742491,240411,372367,178620,646651,784791,396812,573259,434114,917490,871490,842360,971062,535134,409588,292170,410900,800455,189341,775069,651193,623502,67216,187601,28952,87737,645192,502754,488516,565268,225608,876760,811693,431476,960305,868238,154046,244761,190177,481806,959374,869983,431535,175596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]