SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533054 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533054 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966445,374832,88818,381724,210560,555432,989297,53371,885946,475474,1032939,678941,533408,442156,178289,57714,108181,827338,924731,632658,858336,967133,894679,1014440,804872,129934,993083,35322,987022,780388,483120,555002,666707,502869,651605,602957,530804,249135,119124,243306,623946,458073,1041853,332688,113301,547510,696624,94112,738583,334431,977559,934834,748271,666753,358094,878672,989351,470885,814374,577286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]