SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531046 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531046 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238008,429162,757100,870731,103302,539305,183012,25576,943901,899488,668262,747591,814019,308462,621993,451149,435713,704209,337477,1031968,643892,794405,452990,856971,76066,60681,943051,260795,7521,248619,279033,845932,157701,134362,931307,280273,188043,540885,493594,664909,18962,749699,447434,681554,355721,1026193,246260,650513,955730,580300,670174,74107,885272,719363,104365,483096,561088,104094,366677,653855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]