SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502910 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502910 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005009,487271,785947,902016,445013,1042184,392857,431812,515561,123402,838663,46699,18987,157652,42634,337139,176603,1025917,936967,728137,153657,174213,855829,5289,31822,29150,590769,101652,103652,1076,883042,651823,693537,1020105,745445,924179,487234,77032,225041,416016,429442,95456,609869,459243,524242,491364,521023,378767,163552,956165,1028128,645125,815546,739578,776373,653175,253227,900095,956198,668719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]