SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38495 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38495 [ RunTime:0.003576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447167,870154,1038420,200131,474615,308196,312609,33920,231620,10463,75634,185666,32088,159816,646668,106046,433002,337219,969286,717456,684603,950345,928070,1020136,289539,527963,847727,937431,403703,781852,553532,771221,787600,2739,378016,349181,374002,797174,1017930,423126,386475,288951,951913,955906,978942,1039063,72654,480648,132615,645914,494150,961057,411007,592949,740600,7269,847350,799890,731327,151593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]