SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567012 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567012 [ RunTime:0.007273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278145,698401,501100,1019564,1021904,398812,172355,285182,183883,539350,821735,814922,400998,29212,112940,425759,14151,531428,448545,863487,139508,130520,708479,744469,864952,825594,886632,131448,139585,904142,516041,973163,865539,467793,403422,308180,950623,627542,970904,924528,227411,554612,859149,361858,119337,245005,192019,885129,812010,948475,389370,568383,649970,931954,369591,213283,789036,960255,630707,1038768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]