SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.010042s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403618 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403618 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661518,461783,211698,454790,37162,190605,1041910,23134,581410,647074,294546,63339,150151,379982,28142,892638,406461,602627,759057,553677,611736,828292,450772,843375,705079,157989,865820,24896,106055,500900,1036990,470986,151711,784027,883679,311265,662004,623772,976584,433517,452385,739967,645954,39581,762938,183225,406314,18368,630129,660521,376573,846157,274105,176268,626458,960083,516396,781426,122162,687686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]