SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555976 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555976 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133601,552977,157158,95681,7046,147982,832054,1024480,793230,622764,572285,885109,290867,11874,154018,813412,129478,443915,734440,441784,816391,257546,755596,421682,227685,83054,161291,914674,854323,407170,36279,355019,164692,1017484,809891,553318,611849,295140,832983,930343,567689,762253,815552,71415,899266,429806,585714,588550,679651,962954,154228,969231,892549,665494,699678,35246,519790,732219,947815,732994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]