SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545908 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545908 [ RunTime:0.003319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330033,156406,304679,680833,5887,1014168,602504,153949,38523,392086,286913,712205,18765,839413,530699,956223,2119,433772,141805,81587,160630,333166,162265,901051,350307,196264,824977,887568,105109,161104,276926,809611,193649,385270,32867,712999,963330,485707,481535,559769,831039,128230,673342,982313,478096,903492,872409,408366,311869,962844,638248,372362,255607,815007,52775,264309,932232,814745,231161,40911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]