SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40401 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40401 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173238,558551,238532,133279,17111,758654,171451,192930,821541,635046,844368,375683,479701,237498,380051,1011800,916914,1043059,236811,601574,472621,29205,278368,939245,645890,29354,841518,861265,697381,885626,953544,623103,662121,138863,872554,824878,167330,331469,191020,556270,382015,355193,93787,843918,146910,580434,886810,498332,917326,121365,863790,962747,941212,592473,514549,860478,133134,557896,622760,313343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]