SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525613 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525613 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47171,1000579,685781,165014,570759,360511,524116,481236,42719,754311,723766,981549,711995,803015,422686,898817,361694,687482,131676,259288,158681,741112,375272,24860,696133,327553,285058,133101,939272,985632,958110,210638,869007,850892,246744,87280,437691,306698,964428,340024,208059,11850,472598,725376,598655,583101,612851,840156,81283,407511,983549,539348,707222,326668,1044274,7106,926989,412830,474243,495257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]