SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042091 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042091 [ RunTime:0.003913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267215,715564,389509,596143,402980,564896,42055,558238,266048,893600,888101,145731,438877,708504,503755,276704,869150,739636,694450,27006,243410,192208,777589,619833,181690,923747,1029832,854476,674496,40774,826426,32068,952194,336141,626074,359757,910368,1025640,865080,576928,895412,796437,683664,423211,864332,326324,707183,860679,804431,69606,974838,363162,534140,206327,114944,561380,655428,101717,296007,156653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002358s ]