SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425102 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425102 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503648,604679,595251,223188,491362,222334,532738,394505,863788,739883,138485,665726,973988,47553,175759,724274,260322,488114,342797,548510,999584,291675,79196,763459,919202,858946,450065,867695,160151,658143,842547,986481,705537,291900,523632,15784,705129,171700,658057,774173,656893,728378,683232,899461,361090,59056,825754,369255,968759,856115,502700,871277,971593,778563,544428,869386,36139,38726,273578,515293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001781s ]