SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 825510 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 825510 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10647,848344,494451,540780,87166,82743,166736,83790,663420,683967,242959,116826,706451,1000490,209742,1014322,865950,835053,698356,540705,237341,618210,165227,983700,219398,690545,395574,281158,159958,895637,777268,1013670,871235,846779,481175,694711,364046,75385,939564,563610,18617,572147,1013151,171053,393000,770334,771757,234070,68953,985776,582503,973968,208433,88733,643679,556420,907089,212192,22958,294571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 825510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 825510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]